//package com.sankuai.meituan.controller;
//
////import com.sankuai.meituan.cbc.loyalty.console.infrastructure.model.customerop.SmsRecordInfraModel;
////import com.sankuai.meituan.cbc.loyalty.console.infrastructure.repository.mapper.SmsRecordInfraModelMapper;
//
////import com.sankuai.meituan.cbc.loyalty.console.infrastructure.model.customerop.SmsRecordInfraModel;
////import com.sankuai.meituan.cbc.loyalty.console.infrastructure.repository.mapper.SmsRecordInfraModelMapper;
////
////import com.alibaba.excel.EasyExcel;
////import com.sankuai.meituan.cbc.loyalty.console.infrastructure.model.customerop.BankLocation;
////import com.sankuai.meituan.cbc.loyalty.console.infrastructure.repository.mapper.BankLocationMapper;
////import com.sankuai.meituan.util.AddressData;
////import com.sankuai.meituan.util.DemoDataListener;
//import lombok.extern.slf4j.Slf4j;
//import org.springframework.beans.factory.annotation.Autowired;
//import org.springframework.web.bind.annotation.RequestMapping;
//import org.springframework.web.bind.annotation.ResponseBody;
//import org.springframework.web.bind.annotation.RestController;
//
//import javax.annotation.Resource;
//import java.text.ParseException;
//import java.util.Date;
//import java.util.LinkedList;
//import java.util.List;
//
///**
// * @program: mybatisUtil
// * @description:
// * @author: fengleifeng
// * @create: 2020-06-02 19:19
// **/
//@RestController
//@Slf4j
//public class ControllerOne {
//
////    @Resource
////    private SmsRecordInfraModelMapper smsRecordInfraModelMapper;
//
//    @RequestMapping("/userApplySubmit")
//    @ResponseBody
//    private void aa(
////            @RequestBody JSONObject userApplicationForm,
////            @RequestParam("value") String value
//    ) throws ParseException {
////        List<CouponRecordInfraModel> couponRecordInfraModelList = couponRecordInfraModelMapper.queryByStatusAndSize("NEW", 100);
////        CouponConfigInfraModel couponConfigInfraModel = new CouponConfigInfraModel();
////        couponConfigInfraModel.setAddTime(new Date());
////        couponConfigInfraModel.setUpdateTime(new Date());
////        couponConfigInfraModelMapper.insertSelective(couponConfigInfraModel);
////        CardApplicationInfraModel cardApplicationInfraModel = cardApplicationInfraModelMapper
////                .selectOneByUserIdAndCardMetaId(5025062384L,9,null);
////
////        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
////        Date date  = sdf.parse(cardApplicationInfraModel.getMtApplyTime());
////        System.out.println(date.getTime());
////        System.out.println("--");
////        System.out.println("--");
////        List<SmsRecordInfraModel> smsRecordInfraModelList = new LinkedList<>();
////        Date date = new Date();
////        for (int i = 0; i < 100; i++) {
////            smsRecordInfraModelList = new LinkedList<>();
////            for (int j = 0; j < 1000; j++) {
////                SmsRecordInfraModel one = new SmsRecordInfraModel();
////                one.setUpdateTime(date);
////                smsRecordInfraModelList.add(one);
////            }
////            int i1 = smsRecordInfraModelMapper.insertBatch(smsRecordInfraModelList);
////            log.info("数量：" + i1);
////        }
////        log.info("结束" );
//
//    }
////    @Resource
////    private BankLocationMapper bankLocationMapper;
//
//    @RequestMapping("/userApply2")
//    @ResponseBody
//    private void userApply2() throws ParseException {
//
////        BankLocation bankLocation1 = bankLocationMapper.selectByPrimaryKey(1L);
//
//
//        // 有个很重要的点 DemoDataListener 不能被spring管理，要每次读取excel都要new,然后里面用到spring可以构造方法传进去
//        // 写法1：
//        String fileName = "/Users/fengleifeng/业务相关/扬州美食卡/江苏银行网点信息-改-改.xlsx";
//
////        String fileName = TestFileUtil.getPath() + "demo" + File.separator + "demo.xlsx";
//        // 这里 需要指定读用哪个class去读，然后读取第一个sheet 文件流会自动关闭
////        EasyExcel.read(fileName, AddressData.class, new DemoDataListener(bankLocationMapper)).sheet().doRead();
//
//        // 写法2：
////        fileName = TestFileUtil.getPath() + "demo" + File.separator + "demo.xlsx";
////        ExcelReader excelReader = EasyExcel.read(fileName, DemoData.class, new DemoDataListener()).build();
////        ReadSheet readSheet = EasyExcel.readSheet(0).build();
////        excelReader.read(readSheet);
////        // 这里千万别忘记关闭，读的时候会创建临时文件，到时磁盘会崩的
////        excelReader.finish();
//    }
//}
